Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 2719136 |
| Missing cells | 941627 |
| Missing cells (%) | 1.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.9 GiB |
| Average record size in memory | 1.1 KiB |
Variable types
| Categorical | 14 |
|---|---|
| Numeric | 12 |
| Boolean | 1 |
Category has constant value "DRUGS" | Constant |
SpecialisationName has a high cardinality: 95 distinct values | High cardinality |
BillNo has a high cardinality: 1099192 distinct values | High cardinality |
BillDate has a high cardinality: 1527 distinct values | High cardinality |
ItemName has a high cardinality: 4364 distinct values | High cardinality |
Item_Code has a high cardinality: 4223 distinct values | High cardinality |
GenericName has a high cardinality: 2962 distinct values | High cardinality |
UHID is highly overall correlated with Bill_Year | High correlation |
TQty is highly overall correlated with ReturnMRP | High correlation |
UCPwithoutGST is highly overall correlated with MRP and 2 other fields | High correlation |
PurGSTPer is highly overall correlated with TotalDiscount | High correlation |
MRP is highly overall correlated with UCPwithoutGST and 2 other fields | High correlation |
TotalCost is highly overall correlated with UCPwithoutGST and 2 other fields | High correlation |
TotalDiscount is highly overall correlated with PurGSTPer | High correlation |
NetSales is highly overall correlated with UCPwithoutGST and 3 other fields | High correlation |
ReturnMRP is highly overall correlated with TQty and 1 other fields | High correlation |
Bill_Month is highly overall correlated with Bill_Week | High correlation |
Bill_Week is highly overall correlated with Bill_Month | High correlation |
SalesType is highly overall correlated with PharmacyType | High correlation |
PharmacyType is highly overall correlated with SalesType and 1 other fields | High correlation |
Department is highly overall correlated with PharmacyType | High correlation |
IsFormulary is highly overall correlated with Formulary | High correlation |
Formulary is highly overall correlated with IsFormulary | High correlation |
Bill_Year is highly overall correlated with UHID | High correlation |
SalesType is highly imbalanced (50.7%) | Imbalance |
Department is highly imbalanced (73.6%) | Imbalance |
IsFormulary is highly imbalanced (51.3%) | Imbalance |
Formulary is highly imbalanced (61.0%) | Imbalance |
SubCategory is highly imbalanced (53.9%) | Imbalance |
UHID has 156637 (5.8%) missing values | Missing |
Department has 442465 (16.3%) missing values | Missing |
Formulary has 332707 (12.2%) missing values | Missing |
UCPwithoutGST is highly skewed (γ1 = 63.87752404) | Skewed |
MRP is highly skewed (γ1 = 50.22161308) | Skewed |
TotalCost is highly skewed (γ1 = 39.50248905) | Skewed |
TotalDiscount is highly skewed (γ1 = 285.8811301) | Skewed |
NetSales is highly skewed (γ1 = 31.18778957) | Skewed |
ReturnMRP is highly skewed (γ1 = 42.28664228) | Skewed |
PurGSTPer has 2105336 (77.4%) zeros | Zeros |
TotalDiscount has 2321505 (85.4%) zeros | Zeros |
NetSales has 269495 (9.9%) zeros | Zeros |
ReturnMRP has 2450236 (90.1%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-08 13:34:48.098751 |
|---|---|
| Analysis finished | 2023-05-08 13:39:10.250625 |
| Duration | 4 minutes and 22.15 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
SalesType
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 197.1 MiB |
| IP Dispense | |
|---|---|
| OTC Dispense | |
| IP Return | |
| OP Dispense | 30203 |
| OTC Return | 7347 |
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 11.016959 |
| Min length | 9 |
Characters and Unicode
| Total characters | 29956611 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IP Dispense |
|---|---|
| 2nd row | IP Dispense |
| 3rd row | IP Dispense |
| 4th row | IP Dispense |
| 5th row | IP Dispense |
Common Values
| Value | Count | Frequency (%) |
| IP Dispense | 1843450 | |
| OTC Dispense | 576578 | 21.2% |
| IP Return | 261364 | 9.6% |
| OP Dispense | 30203 | 1.1% |
| OTC Return | 7347 | 0.3% |
| OP Return | 194 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| dispense | 2450231 | |
| ip | 2104814 | |
| otc | 583925 | 10.7% |
| return | 268905 | 4.9% |
| op | 30397 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 5169367 | |
| s | 4900462 | |
| 2719136 | ||
| n | 2719136 | |
| D | 2450231 | |
| i | 2450231 | |
| p | 2450231 | |
| P | 2135211 | |
| I | 2104814 | |
| O | 614322 | 2.1% |
| Other values (6) | 2243470 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 18496142 | |
| Uppercase Letter | 8741333 | |
| Space Separator | 2719136 | 9.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 5169367 | |
| s | 4900462 | |
| n | 2719136 | |
| i | 2450231 | |
| p | 2450231 | |
| t | 268905 | 1.5% |
| u | 268905 | 1.5% |
| r | 268905 | 1.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 2450231 | |
| P | 2135211 | |
| I | 2104814 | |
| O | 614322 | 7.0% |
| T | 583925 | 6.7% |
| C | 583925 | 6.7% |
| R | 268905 | 3.1% |
Space Separator
| Value | Count | Frequency (%) |
| 2719136 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27237475 | |
| Common | 2719136 | 9.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 5169367 | |
| s | 4900462 | |
| n | 2719136 | |
| D | 2450231 | |
| i | 2450231 | |
| p | 2450231 | |
| P | 2135211 | |
| I | 2104814 | |
| O | 614322 | 2.3% |
| T | 583925 | 2.1% |
| Other values (5) | 1659545 | 6.1% |
Common
| Value | Count | Frequency (%) |
| 2719136 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 29956611 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 5169367 | |
| s | 4900462 | |
| 2719136 | ||
| n | 2719136 | |
| D | 2450231 | |
| i | 2450231 | |
| p | 2450231 | |
| P | 2135211 | |
| I | 2104814 | |
| O | 614322 | 2.1% |
| Other values (6) | 2243470 |
UHID
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 58130 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 156637 |
| Missing (%) | 5.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2018057 × 1010 |
| Minimum | 1.2018 × 1010 |
|---|---|
| Maximum | 1.2018136 × 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 1.2018 × 1010 |
|---|---|
| 5-th percentile | 1.2018003 × 1010 |
| Q1 | 1.2018022 × 1010 |
| median | 1.2018052 × 1010 |
| Q3 | 1.2018089 × 1010 |
| 95-th percentile | 1.2018123 × 1010 |
| Maximum | 1.2018136 × 1010 |
| Range | 135522 |
| Interquartile range (IQR) | 67741 |
Descriptive statistics
| Standard deviation | 38728.754 |
|---|---|
| Coefficient of variation (CV) | 3.2225471 × 10-6 |
| Kurtosis | -1.1398444 |
| Mean | 1.2018057 × 1010 |
| Median Absolute Deviation (MAD) | 33026 |
| Skewness | 0.26990207 |
| Sum | 3.0796258 × 1016 |
| Variance | 1.4999164 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.201806711 × 1010 | 3556 | 0.1% |
| 1.201800818 × 1010 | 3356 | 0.1% |
| 1.20180057 × 1010 | 3066 | 0.1% |
| 1.201801635 × 1010 | 2416 | 0.1% |
| 1.201807952 × 1010 | 2311 | 0.1% |
| 1.201808741 × 1010 | 2306 | 0.1% |
| 1.201807345 × 1010 | 2228 | 0.1% |
| 1.201804314 × 1010 | 2195 | 0.1% |
| 1.201810332 × 1010 | 2149 | 0.1% |
| 1.201800347 × 1010 | 2149 | 0.1% |
| Other values (58120) | 2536767 | |
| (Missing) | 156637 | 5.8% |
| Value | Count | Frequency (%) |
| 1.2018 × 1010 | 7 | < 0.1% |
| 1.2018 × 1010 | 15 | < 0.1% |
| 1.2018 × 1010 | 8 | < 0.1% |
| 1.2018 × 1010 | 11 | < 0.1% |
| 1.201800001 × 1010 | 3 | < 0.1% |
| 1.201800001 × 1010 | 6 | < 0.1% |
| 1.201800001 × 1010 | 4 | < 0.1% |
| 1.201800001 × 1010 | 4 | < 0.1% |
| 1.201800001 × 1010 | 185 | |
| 1.201800001 × 1010 | 74 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.201813552 × 1010 | 2 | < 0.1% |
| 1.201813552 × 1010 | 3 | < 0.1% |
| 1.201813552 × 1010 | 2 | < 0.1% |
| 1.201813552 × 1010 | 5 | |
| 1.201813552 × 1010 | 11 | |
| 1.201813552 × 1010 | 7 | |
| 1.201813552 × 1010 | 8 | |
| 1.201813551 × 1010 | 1 | < 0.1% |
| 1.201813551 × 1010 | 8 | |
| 1.201813551 × 1010 | 4 | < 0.1% |
PharmacyType
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 173.9 MiB |
| IP | |
|---|---|
| OP | |
| OTC | 184245 |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.0677587 |
| Min length | 2 |
Characters and Unicode
| Total characters | 5622517 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IP |
|---|---|
| 2nd row | IP |
| 3rd row | IP |
| 4th row | IP |
| 5th row | IP |
Common Values
| Value | Count | Frequency (%) |
| IP | 2104814 | |
| OP | 430077 | 15.8% |
| OTC | 184245 | 6.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ip | 2104814 | |
| op | 430077 | 15.8% |
| otc | 184245 | 6.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 2534891 | |
| I | 2104814 | |
| O | 614322 | 10.9% |
| T | 184245 | 3.3% |
| C | 184245 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 5622517 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2534891 | |
| I | 2104814 | |
| O | 614322 | 10.9% |
| T | 184245 | 3.3% |
| C | 184245 | 3.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5622517 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 2534891 | |
| I | 2104814 | |
| O | 614322 | 10.9% |
| T | 184245 | 3.3% |
| C | 184245 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5622517 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 2534891 | |
| I | 2104814 | |
| O | 614322 | 10.9% |
| T | 184245 | 3.3% |
| C | 184245 | 3.3% |
SpecialisationName
Categorical
| Distinct | 95 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Memory size | 224.5 MiB |
| Liver Disease and Transplantation | |
|---|---|
| Hepatology | |
| Covid Care Team | |
| Internal Medicine and Diabetology | |
| Cardiology | 93219 |
| Other values (90) |
Length
| Max length | 62 |
|---|---|
| Median length | 53 |
| Mean length | 21.283485 |
| Min length | 4 |
Characters and Unicode
| Total characters | 57871626 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Liver Disease and Transplantation |
|---|---|
| 2nd row | Liver Disease and Transplantation |
| 3rd row | Liver Disease and Transplantation |
| 4th row | Liver Disease and Transplantation |
| 5th row | Liver Disease and Transplantation |
Common Values
| Value | Count | Frequency (%) |
| Liver Disease and Transplantation | 667071 | |
| Hepatology | 413521 | |
| Covid Care Team | 248655 | 9.1% |
| Internal Medicine and Diabetology | 156780 | 5.8% |
| Cardiology | 93219 | 3.4% |
| Emergency Medicine | 90025 | 3.3% |
| Obstetrics & Gynaecology | 80036 | 2.9% |
| Medical Oncology | 79547 | 2.9% |
| Neurosurgery | 72738 | 2.7% |
| Pediatric Hemato Oncology | 71929 | 2.6% |
| Other values (85) | 745565 |
Length
| Value | Count | Frequency (%) |
| and | 950749 | |
| transplantation | 706016 | 10.0% |
| liver | 697700 | 9.9% |
| disease | 672651 | 9.5% |
| hepatology | 481559 | 6.8% |
| medicine | 347003 | 4.9% |
| care | 296137 | 4.2% |
| covid | 248655 | 3.5% |
| team | 248655 | 3.5% |
| internal | 204067 | 2.9% |
| Other values (106) | 2218598 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6271926 | 10.8% |
| e | 5744754 | 9.9% |
| n | 4601010 | 8.0% |
| i | 4355759 | 7.5% |
| 4352704 | 7.5% | |
| o | 4037067 | 7.0% |
| r | 3359113 | 5.8% |
| t | 3300373 | 5.7% |
| s | 2651480 | 4.6% |
| l | 2477952 | 4.3% |
| Other values (41) | 16719488 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 47219035 | |
| Uppercase Letter | 6100200 | 10.5% |
| Space Separator | 4352704 | 7.5% |
| Other Punctuation | 181425 | 0.3% |
| Dash Punctuation | 18248 | < 0.1% |
| Open Punctuation | 7 | < 0.1% |
| Close Punctuation | 7 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6271926 | |
| e | 5744754 | |
| n | 4601010 | |
| i | 4355759 | |
| o | 4037067 | |
| r | 3359113 | |
| t | 3300373 | 7.0% |
| s | 2651480 | 5.6% |
| l | 2477952 | 5.2% |
| d | 2095912 | 4.4% |
| Other values (13) | 8323689 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 962103 | |
| D | 855870 | |
| L | 711566 | |
| C | 687503 | |
| H | 594065 | |
| M | 535945 | |
| O | 346557 | 5.7% |
| I | 296662 | 4.9% |
| P | 288564 | 4.7% |
| N | 182141 | 3.0% |
| Other values (11) | 639224 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 159440 | |
| , | 21985 | 12.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 9350 | |
| – | 8898 |
Space Separator
| Value | Count | Frequency (%) |
| 4352704 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 7 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 7 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 53319235 | |
| Common | 4552391 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6271926 | |
| e | 5744754 | 10.8% |
| n | 4601010 | 8.6% |
| i | 4355759 | 8.2% |
| o | 4037067 | 7.6% |
| r | 3359113 | 6.3% |
| t | 3300373 | 6.2% |
| s | 2651480 | 5.0% |
| l | 2477952 | 4.6% |
| d | 2095912 | 3.9% |
| Other values (34) | 14423889 |
Common
| Value | Count | Frequency (%) |
| 4352704 | ||
| & | 159440 | 3.5% |
| , | 21985 | 0.5% |
| - | 9350 | 0.2% |
| – | 8898 | 0.2% |
| ( | 7 | < 0.1% |
| ) | 7 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 57862728 | |
| Punctuation | 8898 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 6271926 | 10.8% |
| e | 5744754 | 9.9% |
| n | 4601010 | 8.0% |
| i | 4355759 | 7.5% |
| 4352704 | 7.5% | |
| o | 4037067 | 7.0% |
| r | 3359113 | 5.8% |
| t | 3300373 | 5.7% |
| s | 2651480 | 4.6% |
| l | 2477952 | 4.3% |
| Other values (40) | 16710590 |
Punctuation
| Value | Count | Frequency (%) |
| – | 8898 |
Department
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 442465 |
| Missing (%) | 16.3% |
| Memory size | 189.1 MiB |
| MS IP Pharmacy | |
|---|---|
| SS OT Pharmacy | 181524 |
| New MS OP Pharmacy-GF | 82630 |
| SS ORAGADAM. | 34088 |
| SS Cath Lab Store | 26049 |
| Other values (7) | 34642 |
Length
| Max length | 28 |
|---|---|
| Median length | 14 |
| Mean length | 14.331921 |
| Min length | 12 |
Characters and Unicode
| Total characters | 32629070 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MS IP Pharmacy |
|---|---|
| 2nd row | MS IP Pharmacy |
| 3rd row | MS IP Pharmacy |
| 4th row | MS IP Pharmacy |
| 5th row | MS IP Pharmacy |
Common Values
| Value | Count | Frequency (%) |
| MS IP Pharmacy | 1917738 | |
| SS OT Pharmacy | 181524 | 6.7% |
| New MS OP Pharmacy-GF | 82630 | 3.0% |
| SS ORAGADAM. | 34088 | 1.3% |
| SS Cath Lab Store | 26049 | 1.0% |
| New MS OP Pharmacy-2F | 23958 | 0.9% |
| SS COVID STORE | 9864 | 0.4% |
| SS OP VACCINE | 781 | < 0.1% |
| MS Flu ER Dispensing Counter | 23 | < 0.1% |
| MS OP Pharmacy-GF | 9 | < 0.1% |
| Other values (2) | 7 | < 0.1% |
| (Missing) | 442465 | 16.3% |
Length
| Value | Count | Frequency (%) |
| pharmacy | 2099262 | |
| ms | 2024365 | |
| ip | 1917740 | |
| ss | 252306 | 3.6% |
| ot | 181524 | 2.6% |
| op | 107383 | 1.5% |
| new | 106588 | 1.5% |
| pharmacy-gf | 82639 | 1.2% |
| store | 35913 | 0.5% |
| oragadam | 34088 | 0.5% |
| Other values (10) | 86800 | 1.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4651937 | ||
| a | 4463830 | |
| P | 4230989 | |
| S | 2564890 | |
| r | 2231938 | |
| h | 2231915 | |
| y | 2205866 | |
| c | 2205866 | |
| m | 2205866 | |
| M | 2058453 | |
| Other values (28) | 3577520 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15889074 | |
| Uppercase Letter | 11923406 | |
| Space Separator | 4651937 | 14.3% |
| Dash Punctuation | 106602 | 0.3% |
| Other Punctuation | 34088 | 0.1% |
| Decimal Number | 23963 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4463830 | |
| r | 2231938 | |
| h | 2231915 | |
| y | 2205866 | |
| c | 2205866 | |
| m | 2205866 | |
| e | 132683 | 0.8% |
| w | 106588 | 0.7% |
| t | 52121 | 0.3% |
| o | 26074 | 0.2% |
| Other values (8) | 26327 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 4230989 | |
| S | 2564890 | |
| M | 2058453 | |
| I | 1928385 | |
| O | 342723 | 2.9% |
| T | 191388 | 1.6% |
| G | 116727 | 1.0% |
| N | 107369 | 0.9% |
| F | 106625 | 0.9% |
| A | 103045 | 0.9% |
| Other values (6) | 172812 | 1.4% |
Space Separator
| Value | Count | Frequency (%) |
| 4651937 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 106602 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 34088 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 23963 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27812480 | |
| Common | 4816590 | 14.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4463830 | |
| P | 4230989 | |
| S | 2564890 | |
| r | 2231938 | |
| h | 2231915 | |
| y | 2205866 | |
| c | 2205866 | |
| m | 2205866 | |
| M | 2058453 | |
| I | 1928385 | |
| Other values (24) | 1484482 | 5.3% |
Common
| Value | Count | Frequency (%) |
| 4651937 | ||
| - | 106602 | 2.2% |
| . | 34088 | 0.7% |
| 2 | 23963 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 32629070 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4651937 | ||
| a | 4463830 | |
| P | 4230989 | |
| S | 2564890 | |
| r | 2231938 | |
| h | 2231915 | |
| y | 2205866 | |
| c | 2205866 | |
| m | 2205866 | |
| M | 2058453 | |
| Other values (28) | 3577520 |
BillNo
Categorical
| Distinct | 1099192 |
|---|---|
| Distinct (%) | 40.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.4 MiB |
| OPPDS22-04858 | 190 |
|---|---|
| OTCPDS22-04858 | 56 |
| PDS21-141817 | 51 |
| PDS20-164638 | 50 |
| PDS21-51030 | 46 |
| Other values (1099187) |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 11.891973 |
| Min length | 11 |
Characters and Unicode
| Total characters | 32335893 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 597430 ? |
|---|---|
| Unique (%) | 22.0% |
Sample
| 1st row | PDS19-08659 |
|---|---|
| 2nd row | PDS19-08923 |
| 3rd row | PDS19-08981 |
| 4th row | PDS19-08981 |
| 5th row | PDS19-08981 |
Common Values
| Value | Count | Frequency (%) |
| OPPDS22-04858 | 190 | < 0.1% |
| OTCPDS22-04858 | 56 | < 0.1% |
| PDS21-141817 | 51 | < 0.1% |
| PDS20-164638 | 50 | < 0.1% |
| PDS21-51030 | 46 | < 0.1% |
| OPPDS21-10404 | 44 | < 0.1% |
| PDS20-151216 | 43 | < 0.1% |
| PDS20-136208 | 42 | < 0.1% |
| PDS20-131943 | 42 | < 0.1% |
| OTCPDS19-05176 | 42 | < 0.1% |
| Other values (1099182) | 2718530 |
Length
| Value | Count | Frequency (%) |
| oppds22-04858 | 190 | < 0.1% |
| otcpds22-04858 | 56 | < 0.1% |
| pds21-141817 | 51 | < 0.1% |
| pds20-164638 | 50 | < 0.1% |
| pds21-51030 | 46 | < 0.1% |
| oppds21-10404 | 44 | < 0.1% |
| pds20-151216 | 43 | < 0.1% |
| pds20-131943 | 42 | < 0.1% |
| otcpds19-05176 | 42 | < 0.1% |
| pds20-136208 | 42 | < 0.1% |
| Other values (1099182) | 2718530 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 4765257 | |
| 1 | 3665094 | |
| P | 2845832 | |
| S | 2719136 | |
| - | 2719136 | |
| D | 2450546 | 7.6% |
| 0 | 1993691 | 6.2% |
| 9 | 1748097 | 5.4% |
| 3 | 1456931 | 4.5% |
| 4 | 1374098 | 4.2% |
| Other values (9) | 6598075 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 20123962 | |
| Uppercase Letter | 9492795 | |
| Dash Punctuation | 2719136 | 8.4% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 4765257 | |
| 1 | 3665094 | |
| 0 | 1993691 | |
| 9 | 1748097 | 8.7% |
| 3 | 1456931 | 7.2% |
| 4 | 1374098 | 6.8% |
| 5 | 1322804 | 6.6% |
| 6 | 1290330 | 6.4% |
| 7 | 1257186 | 6.2% |
| 8 | 1250474 | 6.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2845832 | |
| S | 2719136 | |
| D | 2450546 | |
| O | 576891 | 6.1% |
| L | 268590 | 2.8% |
| R | 268590 | 2.8% |
| C | 181605 | 1.9% |
| T | 181605 | 1.9% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2719136 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 22843098 | |
| Latin | 9492795 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 4765257 | |
| 1 | 3665094 | |
| - | 2719136 | |
| 0 | 1993691 | |
| 9 | 1748097 | 7.7% |
| 3 | 1456931 | 6.4% |
| 4 | 1374098 | 6.0% |
| 5 | 1322804 | 5.8% |
| 6 | 1290330 | 5.6% |
| 7 | 1257186 | 5.5% |
Latin
| Value | Count | Frequency (%) |
| P | 2845832 | |
| S | 2719136 | |
| D | 2450546 | |
| O | 576891 | 6.1% |
| L | 268590 | 2.8% |
| R | 268590 | 2.8% |
| C | 181605 | 1.9% |
| T | 181605 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 32335893 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 4765257 | |
| 1 | 3665094 | |
| P | 2845832 | |
| S | 2719136 | |
| - | 2719136 | |
| D | 2450546 | 7.6% |
| 0 | 1993691 | 6.2% |
| 9 | 1748097 | 5.4% |
| 3 | 1456931 | 4.5% |
| 4 | 1374098 | 4.2% |
| Other values (9) | 6598075 |
BillDate
Categorical
| Distinct | 1527 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 194.5 MiB |
| 2022-12-20 | 3804 |
|---|---|
| 2023-02-15 | 3778 |
| 2023-02-03 | 3706 |
| 2023-02-24 | 3694 |
| 2023-02-07 | 3655 |
| Other values (1522) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 27191360 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2019-01-30 |
|---|---|
| 2nd row | 2019-01-31 |
| 3rd row | 2019-01-31 |
| 4th row | 2019-01-31 |
| 5th row | 2019-01-31 |
Common Values
| Value | Count | Frequency (%) |
| 2022-12-20 | 3804 | 0.1% |
| 2023-02-15 | 3778 | 0.1% |
| 2023-02-03 | 3706 | 0.1% |
| 2023-02-24 | 3694 | 0.1% |
| 2023-02-07 | 3655 | 0.1% |
| 2023-03-01 | 3631 | 0.1% |
| 2023-01-24 | 3595 | 0.1% |
| 2023-02-16 | 3581 | 0.1% |
| 2022-12-15 | 3561 | 0.1% |
| 2023-03-04 | 3543 | 0.1% |
| Other values (1517) | 2682588 |
Length
| Value | Count | Frequency (%) |
| 2022-12-20 | 3804 | 0.1% |
| 2023-02-15 | 3778 | 0.1% |
| 2023-02-03 | 3706 | 0.1% |
| 2023-02-24 | 3694 | 0.1% |
| 2023-02-07 | 3655 | 0.1% |
| 2023-03-01 | 3631 | 0.1% |
| 2023-01-24 | 3595 | 0.1% |
| 2023-02-16 | 3581 | 0.1% |
| 2022-12-15 | 3561 | 0.1% |
| 2023-03-04 | 3543 | 0.1% |
| Other values (1517) | 2682588 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 7580107 | |
| 0 | 6486672 | |
| - | 5438272 | |
| 1 | 3587656 | |
| 9 | 918831 | 3.4% |
| 3 | 820265 | 3.0% |
| 8 | 487728 | 1.8% |
| 5 | 475930 | 1.8% |
| 7 | 469444 | 1.7% |
| 4 | 466863 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 21753088 | |
| Dash Punctuation | 5438272 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 7580107 | |
| 0 | 6486672 | |
| 1 | 3587656 | |
| 9 | 918831 | 4.2% |
| 3 | 820265 | 3.8% |
| 8 | 487728 | 2.2% |
| 5 | 475930 | 2.2% |
| 7 | 469444 | 2.2% |
| 4 | 466863 | 2.1% |
| 6 | 459592 | 2.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5438272 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 27191360 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 7580107 | |
| 0 | 6486672 | |
| - | 5438272 | |
| 1 | 3587656 | |
| 9 | 918831 | 3.4% |
| 3 | 820265 | 3.0% |
| 8 | 487728 | 1.8% |
| 5 | 475930 | 1.8% |
| 7 | 469444 | 1.7% |
| 4 | 466863 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27191360 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 7580107 | |
| 0 | 6486672 | |
| - | 5438272 | |
| 1 | 3587656 | |
| 9 | 918831 | 3.4% |
| 3 | 820265 | 3.0% |
| 8 | 487728 | 1.8% |
| 5 | 475930 | 1.8% |
| 7 | 469444 | 1.7% |
| 4 | 466863 | 1.7% |
ItemName
Categorical
| Distinct | 4364 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 280.6 MiB |
| SODIUM CHLORIDE 0.9% 100MLCLARIS | 93660 |
|---|---|
| EMESET (ONDANSETRON) 2ML INJ CIPLA | 58981 |
| KABILYTE (MULTIPLE ELECTROLYTES) 500ML FLEXBAG FRESENIUS | 56517 |
| WATER FOR INJECTION 10ML CLARIS | 49640 |
| SODIUM CHLORIDE 0.9% 500ML (UNIBAG ) CLARIS | 42158 |
| Other values (4359) |
Length
| Max length | 186 |
|---|---|
| Median length | 118 |
| Mean length | 43.159531 |
| Min length | 12 |
Characters and Unicode
| Total characters | 117356635 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 241 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NEKSIUM (ESOMEPRAZOLE) 20MG TAB 1x10 PFIZER |
|---|---|
| 2nd row | FENSTUD (FENTANYL) 50MCG/10ML INJ RUSAN |
| 3rd row | CALCIUM GLUCONATE 10ML INJ 1X1 HINDU |
| 4th row | CLOHEX MOUTH WASH 150ML DR REDDYS |
| 5th row | DEXTROSE 5% 500ML CLARIS |
Common Values
| Value | Count | Frequency (%) |
| SODIUM CHLORIDE 0.9% 100MLCLARIS | 93660 | 3.4% |
| EMESET (ONDANSETRON) 2ML INJ CIPLA | 58981 | 2.2% |
| KABILYTE (MULTIPLE ELECTROLYTES) 500ML FLEXBAG FRESENIUS | 56517 | 2.1% |
| WATER FOR INJECTION 10ML CLARIS | 49640 | 1.8% |
| SODIUM CHLORIDE 0.9% 500ML (UNIBAG ) CLARIS | 42158 | 1.6% |
| SODIUM CHLORIDE 0.9% 100ML FREEFLEX BAG FRESENIUS KABI | 37437 | 1.4% |
| PANSEC (PANTOPRAZOLE) 40MG INJ CIPLA | 33705 | 1.2% |
| LOX JELLY (LIGNOCAINE HYDROCHLORIDE) 2% 30GM GEL NEON | 31712 | 1.2% |
| PARACIP (PARACETAMOL 1GM) 100ML IV INJ CIPLA | 26982 | 1.0% |
| PARIDEM (PANTOPRAZOLE) 40MG INJ EMCURE | 26763 | 1.0% |
| Other values (4354) | 2261581 |
Length
| Value | Count | Frequency (%) |
| inj | 1103097 | 6.4% |
| tab | 541363 | 3.2% |
| 506197 | 2.9% | |
| sodium | 337340 | 2.0% |
| cipla | 322268 | 1.9% |
| chloride | 318692 | 1.9% |
| neon | 291506 | 1.7% |
| 1x10 | 284371 | 1.7% |
| 0.9 | 258831 | 1.5% |
| 100ml | 237819 | 1.4% |
| Other values (5754) | 12964845 |
Most occurring characters
| Value | Count | Frequency (%) |
| 14783213 | 12.6% | |
| E | 7878108 | 6.7% |
| A | 7797036 | 6.6% |
| I | 7659471 | 6.5% |
| L | 6837224 | 5.8% |
| N | 6283348 | 5.4% |
| O | 5904127 | 5.0% |
| M | 5846812 | 5.0% |
| R | 4980870 | 4.2% |
| T | 4676856 | 4.0% |
| Other values (60) | 44709570 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 86695661 | |
| Space Separator | 14783839 | 12.6% |
| Decimal Number | 9425188 | 8.0% |
| Open Punctuation | 2170817 | 1.8% |
| Close Punctuation | 2169438 | 1.8% |
| Other Punctuation | 1130874 | 1.0% |
| Lowercase Letter | 507917 | 0.4% |
| Math Symbol | 407600 | 0.3% |
| Dash Punctuation | 65252 | 0.1% |
| Connector Punctuation | 31 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 7878108 | 9.1% |
| A | 7797036 | 9.0% |
| I | 7659471 | 8.8% |
| L | 6837224 | 7.9% |
| N | 6283348 | 7.2% |
| O | 5904127 | 6.8% |
| M | 5846812 | 6.7% |
| R | 4980870 | 5.7% |
| T | 4676856 | 5.4% |
| C | 4159306 | 4.8% |
| Other values (17) | 24672503 |
Lowercase Letter
| Value | Count | Frequency (%) |
| x | 490326 | |
| r | 7663 | 1.5% |
| g | 3415 | 0.7% |
| m | 3370 | 0.7% |
| s | 441 | 0.1% |
| c | 321 | 0.1% |
| o | 319 | 0.1% |
| e | 319 | 0.1% |
| t | 319 | 0.1% |
| f | 319 | 0.1% |
| Other values (7) | 1105 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3745782 | |
| 1 | 2373015 | |
| 5 | 1390271 | 14.8% |
| 2 | 738786 | 7.8% |
| 4 | 443735 | 4.7% |
| 9 | 274766 | 2.9% |
| 3 | 258011 | 2.7% |
| 6 | 124398 | 1.3% |
| 7 | 48084 | 0.5% |
| 8 | 28340 | 0.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 576541 | |
| % | 436838 | |
| / | 104854 | 9.3% |
| & | 9706 | 0.9% |
| , | 2935 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 14783213 | ||
| Â | 626 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2170810 | |
| [ | 7 | < 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2169431 | |
| ] | 7 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 407589 | |
| | | 11 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 65252 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 31 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 18 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 87203578 | |
| Common | 30153057 | 25.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 7878108 | 9.0% |
| A | 7797036 | 8.9% |
| I | 7659471 | 8.8% |
| L | 6837224 | 7.8% |
| N | 6283348 | 7.2% |
| O | 5904127 | 6.8% |
| M | 5846812 | 6.7% |
| R | 4980870 | 5.7% |
| T | 4676856 | 5.4% |
| C | 4159306 | 4.8% |
| Other values (34) | 25180420 |
Common
| Value | Count | Frequency (%) |
| 14783213 | ||
| 0 | 3745782 | 12.4% |
| 1 | 2373015 | 7.9% |
| ( | 2170810 | 7.2% |
| ) | 2169431 | 7.2% |
| 5 | 1390271 | 4.6% |
| 2 | 738786 | 2.5% |
| . | 576541 | 1.9% |
| 4 | 443735 | 1.5% |
| % | 436838 | 1.4% |
| Other values (16) | 1324635 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 117355174 | |
| None | 1443 | < 0.1% |
| Punctuation | 18 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 14783213 | 12.6% | |
| E | 7878108 | 6.7% |
| A | 7797036 | 6.6% |
| I | 7659471 | 6.5% |
| L | 6837224 | 5.8% |
| N | 6283348 | 5.4% |
| O | 5904127 | 5.0% |
| M | 5846812 | 5.0% |
| R | 4980870 | 4.2% |
| T | 4676856 | 4.0% |
| Other values (57) | 44708109 |
None
| Value | Count | Frequency (%) |
| Â | 817 | |
| Â | 626 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 18 |
Item_Code
Categorical
| Distinct | 4223 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 189.3 MiB |
| PH000579 | 93660 |
|---|---|
| PH000258 | 58981 |
| PH000561 | 56517 |
| PH000439 | 49640 |
| PH000569 | 42158 |
| Other values (4218) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 21753088 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 219 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PH001036 |
|---|---|
| 2nd row | PH001660 |
| 3rd row | PH000543 |
| 4th row | PH000604 |
| 5th row | PH000564 |
Common Values
| Value | Count | Frequency (%) |
| PH000579 | 93660 | 3.4% |
| PH000258 | 58981 | 2.2% |
| PH000561 | 56517 | 2.1% |
| PH000439 | 49640 | 1.8% |
| PH000569 | 42158 | 1.6% |
| PH002839 | 37441 | 1.4% |
| PH000295 | 33705 | 1.2% |
| PH000208 | 31712 | 1.2% |
| PH000589 | 26982 | 1.0% |
| PH003917 | 26763 | 1.0% |
| Other values (4213) | 2261577 |
Length
| Value | Count | Frequency (%) |
| ph000579 | 93660 | 3.4% |
| ph000258 | 58981 | 2.2% |
| ph000561 | 56517 | 2.1% |
| ph000439 | 49640 | 1.8% |
| ph000569 | 42158 | 1.6% |
| ph002839 | 37441 | 1.4% |
| ph000295 | 33705 | 1.2% |
| ph000208 | 31712 | 1.2% |
| ph000589 | 26982 | 1.0% |
| ph003917 | 26763 | 1.0% |
| Other values (4213) | 2261577 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7757521 | |
| P | 2719123 | 12.5% |
| H | 2719123 | 12.5% |
| 1 | 1260130 | 5.8% |
| 3 | 1112357 | 5.1% |
| 5 | 1011620 | 4.7% |
| 2 | 991764 | 4.6% |
| 9 | 943591 | 4.3% |
| 8 | 894900 | 4.1% |
| 6 | 879765 | 4.0% |
| Other values (4) | 1463194 | 6.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 16314816 | |
| Uppercase Letter | 5438272 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7757521 | |
| 1 | 1260130 | 7.7% |
| 3 | 1112357 | 6.8% |
| 5 | 1011620 | 6.2% |
| 2 | 991764 | 6.1% |
| 9 | 943591 | 5.8% |
| 8 | 894900 | 5.5% |
| 6 | 879765 | 5.4% |
| 4 | 747476 | 4.6% |
| 7 | 715692 | 4.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2719123 | |
| H | 2719123 | |
| M | 13 | < 0.1% |
| C | 13 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 16314816 | |
| Latin | 5438272 | 25.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 7757521 | |
| 1 | 1260130 | 7.7% |
| 3 | 1112357 | 6.8% |
| 5 | 1011620 | 6.2% |
| 2 | 991764 | 6.1% |
| 9 | 943591 | 5.8% |
| 8 | 894900 | 5.5% |
| 6 | 879765 | 5.4% |
| 4 | 747476 | 4.6% |
| 7 | 715692 | 4.4% |
Latin
| Value | Count | Frequency (%) |
| P | 2719123 | |
| H | 2719123 | |
| M | 13 | < 0.1% |
| C | 13 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21753088 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 7757521 | |
| P | 2719123 | 12.5% |
| H | 2719123 | 12.5% |
| 1 | 1260130 | 5.8% |
| 3 | 1112357 | 5.1% |
| 5 | 1011620 | 4.7% |
| 2 | 991764 | 4.6% |
| 9 | 943591 | 4.3% |
| 8 | 894900 | 4.1% |
| 6 | 879765 | 4.0% |
| Other values (4) | 1463194 | 6.7% |
IsFormulary
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.3 MiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 2431846 | |
| False | 287290 | 10.6% |
Formulary
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 332707 |
| Missing (%) | 12.2% |
| Memory size | 165.7 MiB |
| P1 | |
|---|---|
| P2 | |
| Innovator | 72024 |
| P3 | 16798 |
| INNOVATOR | 11418 |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.2454919 |
| Min length | 2 |
Characters and Unicode
| Total characters | 5358707 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | P1 |
|---|---|
| 2nd row | P2 |
| 3rd row | P1 |
| 4th row | P1 |
| 5th row | P1 |
Common Values
| Value | Count | Frequency (%) |
| P1 | 1811418 | |
| P2 | 474186 | 17.4% |
| Innovator | 72024 | 2.6% |
| P3 | 16798 | 0.6% |
| INNOVATOR | 11418 | 0.4% |
| 198.5 | 585 | < 0.1% |
| (Missing) | 332707 | 12.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| p1 | 1811418 | |
| p2 | 474186 | 19.9% |
| innovator | 83442 | 3.5% |
| p3 | 16798 | 0.7% |
| 198.5 | 585 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 2302402 | |
| 1 | 1812003 | |
| 2 | 474186 | 8.8% |
| n | 144048 | 2.7% |
| o | 144048 | 2.7% |
| I | 83442 | 1.6% |
| v | 72024 | 1.3% |
| a | 72024 | 1.3% |
| t | 72024 | 1.3% |
| r | 72024 | 1.3% |
| Other values (11) | 110482 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2477188 | |
| Decimal Number | 2304742 | |
| Lowercase Letter | 576192 | 10.8% |
| Other Punctuation | 585 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2302402 | |
| I | 83442 | 3.4% |
| O | 22836 | 0.9% |
| N | 22836 | 0.9% |
| V | 11418 | 0.5% |
| A | 11418 | 0.5% |
| T | 11418 | 0.5% |
| R | 11418 | 0.5% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1812003 | |
| 2 | 474186 | 20.6% |
| 3 | 16798 | 0.7% |
| 9 | 585 | < 0.1% |
| 8 | 585 | < 0.1% |
| 5 | 585 | < 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 144048 | |
| o | 144048 | |
| v | 72024 | |
| a | 72024 | |
| t | 72024 | |
| r | 72024 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 585 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3053380 | |
| Common | 2305327 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 2302402 | |
| n | 144048 | 4.7% |
| o | 144048 | 4.7% |
| I | 83442 | 2.7% |
| v | 72024 | 2.4% |
| a | 72024 | 2.4% |
| t | 72024 | 2.4% |
| r | 72024 | 2.4% |
| O | 22836 | 0.7% |
| N | 22836 | 0.7% |
| Other values (4) | 45672 | 1.5% |
Common
| Value | Count | Frequency (%) |
| 1 | 1812003 | |
| 2 | 474186 | 20.6% |
| 3 | 16798 | 0.7% |
| 9 | 585 | < 0.1% |
| 8 | 585 | < 0.1% |
| . | 585 | < 0.1% |
| 5 | 585 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5358707 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 2302402 | |
| 1 | 1812003 | |
| 2 | 474186 | 8.8% |
| n | 144048 | 2.7% |
| o | 144048 | 2.7% |
| I | 83442 | 1.6% |
| v | 72024 | 1.3% |
| a | 72024 | 1.3% |
| t | 72024 | 1.3% |
| r | 72024 | 1.3% |
| Other values (11) | 110482 | 2.1% |
TQty
Real number (ℝ)
| Distinct | 271 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4365423 |
| Minimum | -450 |
|---|---|
| Maximum | 1250 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 268905 |
| Negative (%) | 9.9% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | -450 |
|---|---|
| 5-th percentile | -2 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 8 |
| Maximum | 1250 |
| Range | 1700 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 6.5954165 |
|---|---|
| Coefficient of variation (CV) | 2.7068754 |
| Kurtosis | 1164.0116 |
| Mean | 2.4365423 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 16.816578 |
| Sum | 6625290 |
| Variance | 43.499519 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1266708 | |
| 2 | 524272 | |
| 3 | 220060 | 8.1% |
| 4 | 143551 | 5.3% |
| -1 | 131909 | 4.9% |
| 5 | 86702 | 3.2% |
| -2 | 70264 | 2.6% |
| 6 | 56242 | 2.1% |
| 10 | 43501 | 1.6% |
| -3 | 27657 | 1.0% |
| Other values (261) | 148270 | 5.5% |
| Value | Count | Frequency (%) |
| -450 | 1 | < 0.1% |
| -378 | 1 | < 0.1% |
| -360 | 1 | < 0.1% |
| -300 | 2 | < 0.1% |
| -182 | 1 | < 0.1% |
| -180 | 4 | |
| -170 | 1 | < 0.1% |
| -164 | 1 | < 0.1% |
| -160 | 1 | < 0.1% |
| -120 | 8 |
| Value | Count | Frequency (%) |
| 1250 | 1 | |
| 1000 | 1 | |
| 750 | 1 | |
| 720 | 1 | |
| 600 | 1 | |
| 550 | 1 | |
| 540 | 1 | |
| 500 | 2 | |
| 450 | 1 | |
| 405 | 1 |
UCPwithoutGST
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 19059 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 267.00547 |
| Minimum | 0 |
|---|---|
| Maximum | 431504 |
| Zeros | 3355 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.5 |
| Q1 | 14.2 |
| median | 47.46 |
| Q3 | 129.2725 |
| 95-th percentile | 879.29 |
| Maximum | 431504 |
| Range | 431504 |
| Interquartile range (IQR) | 115.0725 |
Descriptive statistics
| Standard deviation | 1473.7664 |
|---|---|
| Coefficient of variation (CV) | 5.5196115 |
| Kurtosis | 9644.2363 |
| Mean | 267.00547 |
| Median Absolute Deviation (MAD) | 38.46 |
| Skewness | 63.877524 |
| Sum | 7.2602418 × 108 |
| Variance | 2171987.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.75 | 77539 | 2.9% |
| 111 | 50399 | 1.9% |
| 49.65 | 38699 | 1.4% |
| 1.78 | 36130 | 1.3% |
| 39 | 32875 | 1.2% |
| 11 | 26733 | 1.0% |
| 13.04 | 23206 | 0.9% |
| 50 | 22718 | 0.8% |
| 4.4 | 20404 | 0.8% |
| 29.8 | 18120 | 0.7% |
| Other values (19049) | 2372313 |
| Value | Count | Frequency (%) |
| 0 | 3355 | |
| 0.01 | 160 | < 0.1% |
| 0.02 | 2 | < 0.1% |
| 0.04 | 5 | < 0.1% |
| 0.06 | 35 | < 0.1% |
| 0.07 | 4 | < 0.1% |
| 0.1 | 154 | < 0.1% |
| 0.11 | 7 | < 0.1% |
| 0.13 | 2 | < 0.1% |
| 0.14 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 431504 | 1 | < 0.1% |
| 296879 | 6 | < 0.1% |
| 230999.99 | 6 | < 0.1% |
| 214678.53 | 2 | < 0.1% |
| 164026 | 1 | < 0.1% |
| 157800 | 15 | |
| 138297.6 | 1 | < 0.1% |
| 135000 | 2 | < 0.1% |
| 128000 | 13 | |
| 104517 | 2 | < 0.1% |
PurGSTPer
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.8100044 |
| Minimum | 0 |
|---|---|
| Maximum | 120 |
| Zeros | 2105336 |
| Zeros (%) | 77.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 12 |
| Maximum | 120 |
| Range | 120 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.6036392 |
|---|---|
| Coefficient of variation (CV) | 1.9941745 |
| Kurtosis | 5.0249423 |
| Mean | 2.8100044 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.0252391 |
| Sum | 7640784 |
| Variance | 31.400772 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2105336 | |
| 12 | 480466 | 17.7% |
| 5 | 59194 | 2.2% |
| 24 | 33824 | 1.2% |
| 18 | 31928 | 1.2% |
| 10 | 4489 | 0.2% |
| 36 | 3012 | 0.1% |
| 48 | 512 | < 0.1% |
| 15 | 90 | < 0.1% |
| 20 | 72 | < 0.1% |
| Other values (12) | 213 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 2105336 | |
| 5 | 59194 | 2.2% |
| 10 | 4489 | 0.2% |
| 12 | 480466 | 17.7% |
| 15 | 90 | < 0.1% |
| 17 | 2 | < 0.1% |
| 18 | 31928 | 1.2% |
| 20 | 72 | < 0.1% |
| 24 | 33824 | 1.2% |
| 25 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 120 | 2 | < 0.1% |
| 108 | 5 | < 0.1% |
| 96 | 3 | < 0.1% |
| 90 | 1 | < 0.1% |
| 84 | 3 | < 0.1% |
| 72 | 69 | < 0.1% |
| 60 | 31 | < 0.1% |
| 54 | 42 | < 0.1% |
| 48 | 512 | < 0.1% |
| 36 | 3012 |
MRP
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 12954 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 497.4035 |
| Minimum | 0.02 |
|---|---|
| Maximum | 555416 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 0.02 |
|---|---|
| 5-th percentile | 5.34 |
| Q1 | 29.06 |
| median | 80 |
| Q3 | 299 |
| 95-th percentile | 2465.1 |
| Maximum | 555416 |
| Range | 555415.98 |
| Interquartile range (IQR) | 269.94 |
Descriptive statistics
| Standard deviation | 2126.8404 |
|---|---|
| Coefficient of variation (CV) | 4.2758855 |
| Kurtosis | 6947.3743 |
| Mean | 497.4035 |
| Median Absolute Deviation (MAD) | 66.88 |
| Skewness | 50.221613 |
| Sum | 1.3525078 × 109 |
| Variance | 4523450.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17.65 | 35047 | 1.3% |
| 17.33 | 28422 | 1.0% |
| 37.92 | 26496 | 1.0% |
| 42 | 24567 | 0.9% |
| 602.55 | 21229 | 0.8% |
| 284 | 16805 | 0.6% |
| 2.56 | 16488 | 0.6% |
| 259 | 16409 | 0.6% |
| 17.74 | 16311 | 0.6% |
| 42.01 | 16311 | 0.6% |
| Other values (12944) | 2501051 |
| Value | Count | Frequency (%) |
| 0.02 | 2 | < 0.1% |
| 0.05 | 8 | < 0.1% |
| 0.08 | 35 | |
| 0.11 | 4 | < 0.1% |
| 0.16 | 7 | < 0.1% |
| 0.2 | 2 | < 0.1% |
| 0.21 | 2 | < 0.1% |
| 0.24 | 6 | < 0.1% |
| 0.34 | 4 | < 0.1% |
| 0.35 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 555416 | 1 | < 0.1% |
| 396725 | 6 | |
| 330000 | 6 | |
| 280000 | 2 | < 0.1% |
| 238999.99 | 2 | < 0.1% |
| 210400 | 6 | |
| 197250 | 9 | |
| 189000 | 2 | < 0.1% |
| 183000 | 1 | < 0.1% |
| 167370 | 1 | < 0.1% |
TotalCost
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 42297 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 495.12128 |
| Minimum | 0 |
|---|---|
| Maximum | 483284.48 |
| Zeros | 3358 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6.85 |
| Q1 | 27.24 |
| median | 87.17 |
| Q3 | 248.64 |
| 95-th percentile | 1816.16 |
| Maximum | 483284.48 |
| Range | 483284.48 |
| Interquartile range (IQR) | 221.4 |
Descriptive statistics
| Standard deviation | 2512.7929 |
|---|---|
| Coefficient of variation (CV) | 5.0751059 |
| Kurtosis | 3562.6036 |
| Mean | 495.12128 |
| Median Absolute Deviation (MAD) | 69.93 |
| Skewness | 39.502489 |
| Sum | 1.3463021 × 109 |
| Variance | 6314128.4 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 43.68 | 30877 | 1.1% |
| 21.84 | 27638 | 1.0% |
| 10.92 | 25713 | 0.9% |
| 12.32 | 19174 | 0.7% |
| 55.61 | 18778 | 0.7% |
| 248.64 | 16759 | 0.6% |
| 32.76 | 16005 | 0.6% |
| 124.32 | 15642 | 0.6% |
| 111.22 | 14883 | 0.5% |
| 24.64 | 14590 | 0.5% |
| Other values (42287) | 2519077 |
| Value | Count | Frequency (%) |
| 0 | 3358 | |
| 0.01 | 12 | < 0.1% |
| 0.02 | 14 | < 0.1% |
| 0.03 | 22 | < 0.1% |
| 0.04 | 32 | < 0.1% |
| 0.06 | 10 | < 0.1% |
| 0.07 | 38 | < 0.1% |
| 0.08 | 45 | < 0.1% |
| 0.09 | 2 | < 0.1% |
| 0.1 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 483284.48 | 1 | < 0.1% |
| 401479.68 | 1 | < 0.1% |
| 376320 | 1 | < 0.1% |
| 363031.2 | 1 | < 0.1% |
| 353472 | 2 | < 0.1% |
| 332504.48 | 6 | |
| 301109.76 | 1 | < 0.1% |
| 292499.87 | 1 | < 0.1% |
| 263424 | 2 | < 0.1% |
| 258719.99 | 6 |
TotalDiscount
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 13071 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5991873 |
| Minimum | -662.56 |
|---|---|
| Maximum | 79999.2 |
| Zeros | 2321505 |
| Zeros (%) | 85.4% |
| Negative | 61 |
| Negative (%) | < 0.1% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | -662.56 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 28.52 |
| Maximum | 79999.2 |
| Range | 80661.76 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 95.441009 |
|---|---|
| Coefficient of variation (CV) | 11.098841 |
| Kurtosis | 200970.97 |
| Mean | 8.5991873 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 285.88113 |
| Sum | 23382360 |
| Variance | 9108.9862 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2321505 | |
| 13.8 | 2423 | 0.1% |
| 10.5 | 2268 | 0.1% |
| 142.5 | 2241 | 0.1% |
| 14.9 | 1978 | 0.1% |
| 3.09 | 1859 | 0.1% |
| 23.9 | 1623 | 0.1% |
| 19 | 1464 | 0.1% |
| 24 | 1429 | 0.1% |
| 11.95 | 1282 | < 0.1% |
| Other values (13061) | 381064 | 14.0% |
| Value | Count | Frequency (%) |
| -662.56 | 1 | < 0.1% |
| -322.82 | 1 | < 0.1% |
| -316.05 | 1 | < 0.1% |
| -237.48 | 1 | < 0.1% |
| -161.4 | 3 | |
| -147.78 | 1 | < 0.1% |
| -129.26 | 1 | < 0.1% |
| -121.06 | 1 | < 0.1% |
| -110.85 | 1 | < 0.1% |
| -106.52 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 79999.2 | 1 | |
| 39999.6 | 1 | |
| 34000 | 1 | |
| 18650.8 | 1 | |
| 14124 | 1 | |
| 13136.58 | 1 | |
| 12312 | 1 | |
| 11999.88 | 1 | |
| 11840.4 | 1 | |
| 11228.76 | 1 |
NetSales
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 42009 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 793.11882 |
| Minimum | -38.3 |
|---|---|
| Maximum | 555416 |
| Zeros | 269495 |
| Zeros (%) | 9.9% |
| Negative | 3 |
| Negative (%) | < 0.1% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | -38.3 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 31.5 |
| median | 108 |
| Q3 | 414 |
| 95-th percentile | 3490 |
| Maximum | 555416 |
| Range | 555454.3 |
| Interquartile range (IQR) | 382.5 |
Descriptive statistics
| Standard deviation | 3422.807 |
|---|---|
| Coefficient of variation (CV) | 4.3156296 |
| Kurtosis | 2533.9107 |
| Mean | 793.11882 |
| Median Absolute Deviation (MAD) | 97.54 |
| Skewness | 31.18779 |
| Sum | 2.1565979 × 109 |
| Variance | 11715608 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 269495 | 9.9% |
| 35.5 | 10251 | 0.4% |
| 17.65 | 10221 | 0.4% |
| 602.55 | 10086 | 0.4% |
| 55.29 | 9769 | 0.4% |
| 35.3 | 8094 | 0.3% |
| 35 | 8045 | 0.3% |
| 65 | 7795 | 0.3% |
| 17.33 | 7310 | 0.3% |
| 37.92 | 7228 | 0.3% |
| Other values (41999) | 2370842 |
| Value | Count | Frequency (%) |
| -38.3 | 1 | < 0.1% |
| -11.83 | 1 | < 0.1% |
| -3.86 | 1 | < 0.1% |
| 0 | 269495 | |
| 0.02 | 1 | < 0.1% |
| 0.04 | 1 | < 0.1% |
| 0.08 | 31 | < 0.1% |
| 0.1 | 1 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 555416 | 1 | < 0.1% |
| 524810 | 1 | < 0.1% |
| 508800 | 1 | < 0.1% |
| 456000 | 1 | < 0.1% |
| 430000 | 1 | < 0.1% |
| 420800 | 2 | < 0.1% |
| 418425 | 1 | < 0.1% |
| 396725 | 6 | |
| 381600 | 1 | < 0.1% |
| 380000 | 1 | < 0.1% |
ReturnMRP
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 11784 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.692677 |
| Minimum | 0 |
|---|---|
| Maximum | 238999.99 |
| Zeros | 2450236 |
| Zeros (%) | 90.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 122.81 |
| Maximum | 238999.99 |
| Range | 238999.99 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 935.54594 |
|---|---|
| Coefficient of variation (CV) | 11.178349 |
| Kurtosis | 4296.5919 |
| Mean | 83.692677 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 42.286642 |
| Sum | 2.2757177 × 108 |
| Variance | 875246.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2450236 | |
| 37.92 | 1996 | 0.1% |
| 17.65 | 1864 | 0.1% |
| 284 | 1811 | 0.1% |
| 42 | 1782 | 0.1% |
| 602.55 | 1776 | 0.1% |
| 17.33 | 1533 | 0.1% |
| 518 | 1523 | 0.1% |
| 259 | 1456 | 0.1% |
| 35.3 | 1454 | 0.1% |
| Other values (11774) | 253705 | 9.3% |
| Value | Count | Frequency (%) |
| 0 | 2450236 | |
| 0.9 | 2 | < 0.1% |
| 0.95 | 3 | < 0.1% |
| 0.96 | 11 | < 0.1% |
| 1 | 2 | < 0.1% |
| 1.06 | 10 | < 0.1% |
| 1.1 | 1 | < 0.1% |
| 1.17 | 3 | < 0.1% |
| 1.21 | 1 | < 0.1% |
| 1.27 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 238999.99 | 1 | |
| 160801.2 | 1 | |
| 148820 | 1 | |
| 143980 | 1 | |
| 136548 | 1 | |
| 123200 | 1 | |
| 112920 | 1 | |
| 107985 | 1 | |
| 105930 | 1 | |
| 101320 | 1 |
GenericName
Categorical
| Distinct | 2962 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 151 |
| Missing (%) | < 0.1% |
| Memory size | 240.3 MiB |
| SODIUM CHLORIDE 0.9% | 219097 |
|---|---|
| PANTOPRAZOLE 40MG INJ | 61812 |
| MULTIPLE ELECTROLYTES 500ML IVF | 60556 |
| ONDANSETRON 2MG/ML | 59346 |
| PARACETAMOL 1GM IV INJ | 55766 |
| Other values (2957) |
Length
| Max length | 287 |
|---|---|
| Median length | 224 |
| Mean length | 27.651424 |
| Min length | 4 |
Characters and Unicode
| Total characters | 75183806 |
|---|---|
| Distinct characters | 76 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 138 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ESOMEPRAZOLE 20MG |
|---|---|
| 2nd row | FENTANYL INJ 500MCG/10ML |
| 3rd row | CALCIUM GLUCONATE |
| 4th row | CHLORHEXIDINE GLUCONATE 0.2%W/V |
| 5th row | DEXTROSE 5% W/V IV FLUID |
Common Values
| Value | Count | Frequency (%) |
| SODIUM CHLORIDE 0.9% | 219097 | 8.1% |
| PANTOPRAZOLE 40MG INJ | 61812 | 2.3% |
| MULTIPLE ELECTROLYTES 500ML IVF | 60556 | 2.2% |
| ONDANSETRON 2MG/ML | 59346 | 2.2% |
| PARACETAMOL 1GM IV INJ | 55766 | 2.1% |
| WATER FOR INJECTION 10ML SOLUTION | 54835 | 2.0% |
| LIGNOCAINE HYDROCHLORIDE 2% INJ | 44678 | 1.6% |
| PIPERACILLIN 4GM+ TAZOBACTAM 500MG | 44082 | 1.6% |
| SODIUM CHLORIDE IVF 100ML | 37441 | 1.4% |
| ENOXAPARIN 40MG | 34938 | 1.3% |
| Other values (2952) | 2046434 |
Length
| Value | Count | Frequency (%) |
| inj | 685650 | 6.4% |
| 633136 | 5.9% | |
| chloride | 428719 | 4.0% |
| sodium | 408464 | 3.8% |
| tab | 321515 | 3.0% |
| 0.9 | 234731 | 2.2% |
| 40mg | 204112 | 1.9% |
| 500mg | 175076 | 1.6% |
| 1gm | 146629 | 1.4% |
| ivf | 141227 | 1.3% |
| Other values (2858) | 7388415 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8069352 | 10.7% | |
| I | 5714572 | 7.6% |
| M | 5100626 | 6.8% |
| E | 4762437 | 6.3% |
| O | 4384886 | 5.8% |
| A | 4321909 | 5.7% |
| L | 4159913 | 5.5% |
| N | 3795551 | 5.0% |
| 0 | 3189844 | 4.2% |
| T | 3031757 | 4.0% |
| Other values (66) | 28652959 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 57031467 | |
| Space Separator | 8070225 | 10.7% |
| Decimal Number | 7631744 | 10.2% |
| Other Punctuation | 1567847 | 2.1% |
| Math Symbol | 769466 | 1.0% |
| Dash Punctuation | 47122 | 0.1% |
| Lowercase Letter | 35931 | < 0.1% |
| Close Punctuation | 12655 | < 0.1% |
| Open Punctuation | 12506 | < 0.1% |
| Control | 4816 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 5714572 | 10.0% |
| M | 5100626 | 8.9% |
| E | 4762437 | 8.4% |
| O | 4384886 | 7.7% |
| A | 4321909 | 7.6% |
| L | 4159913 | 7.3% |
| N | 3795551 | 6.7% |
| T | 3031757 | 5.3% |
| R | 2868123 | 5.0% |
| C | 2760430 | 4.8% |
| Other values (16) | 16131263 |
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 4558 | |
| o | 3238 | 9.0% |
| e | 3151 | 8.8% |
| a | 3065 | 8.5% |
| l | 2496 | 6.9% |
| t | 2089 | 5.8% |
| n | 2014 | 5.6% |
| r | 1935 | 5.4% |
| c | 1890 | 5.3% |
| d | 1821 | 5.1% |
| Other values (15) | 9674 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3189844 | |
| 5 | 1261350 | 16.5% |
| 1 | 1106530 | 14.5% |
| 2 | 784342 | 10.3% |
| 4 | 395444 | 5.2% |
| 9 | 297769 | 3.9% |
| 3 | 243273 | 3.2% |
| 6 | 177597 | 2.3% |
| 7 | 101919 | 1.3% |
| 8 | 73676 | 1.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 617865 | |
| % | 509132 | |
| / | 420516 | |
| , | 18768 | 1.2% |
| & | 1566 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 8069352 | ||
| Â | 873 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 47073 | |
| – | 49 | 0.1% |
Control
| Value | Count | Frequency (%) |
| 3612 | ||
| 1204 | 25.0% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 769466 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 12655 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 12506 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 27 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 57067398 | |
| Common | 18116408 | 24.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 5714572 | 10.0% |
| M | 5100626 | 8.9% |
| E | 4762437 | 8.3% |
| O | 4384886 | 7.7% |
| A | 4321909 | 7.6% |
| L | 4159913 | 7.3% |
| N | 3795551 | 6.7% |
| T | 3031757 | 5.3% |
| R | 2868123 | 5.0% |
| C | 2760430 | 4.8% |
| Other values (41) | 16167194 |
Common
| Value | Count | Frequency (%) |
| 8069352 | ||
| 0 | 3189844 | 17.6% |
| 5 | 1261350 | 7.0% |
| 1 | 1106530 | 6.1% |
| 2 | 784342 | 4.3% |
| + | 769466 | 4.2% |
| . | 617865 | 3.4% |
| % | 509132 | 2.8% |
| / | 420516 | 2.3% |
| 4 | 395444 | 2.2% |
| Other values (15) | 992567 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75182884 | |
| None | 873 | < 0.1% |
| Punctuation | 49 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8069352 | 10.7% | |
| I | 5714572 | 7.6% |
| M | 5100626 | 6.8% |
| E | 4762437 | 6.3% |
| O | 4384886 | 5.8% |
| A | 4321909 | 5.7% |
| L | 4159913 | 5.5% |
| N | 3795551 | 5.0% |
| 0 | 3189844 | 4.2% |
| T | 3031757 | 4.0% |
| Other values (64) | 28652037 |
None
| Value | Count | Frequency (%) |
| Â | 873 |
Punctuation
| Value | Count | Frequency (%) |
| – | 49 |
Category
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 181.5 MiB |
| DRUGS |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 13595680 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DRUGS |
|---|---|
| 2nd row | DRUGS |
| 3rd row | DRUGS |
| 4th row | DRUGS |
| 5th row | DRUGS |
Common Values
| Value | Count | Frequency (%) |
| DRUGS | 2719136 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| drugs | 2719136 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 2719136 | |
| R | 2719136 | |
| U | 2719136 | |
| G | 2719136 | |
| S | 2719136 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 13595680 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 2719136 | |
| R | 2719136 | |
| U | 2719136 | |
| G | 2719136 | |
| S | 2719136 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 13595680 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 2719136 | |
| R | 2719136 | |
| U | 2719136 | |
| G | 2719136 | |
| S | 2719136 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13595680 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 2719136 | |
| R | 2719136 | |
| U | 2719136 | |
| G | 2719136 | |
| S | 2719136 |
SubCategory
Categorical
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 210.3 MiB |
| INJECTIONS | |
|---|---|
| TABLETS & CAPSULES | |
| IV FLUIDS, ELECTROLYTES, TPN | |
| SYRUP & SUSPENSION | 89640 |
| OINTMENTS, CREAMS & GELS | 69245 |
| Other values (28) |
Length
| Max length | 28 |
|---|---|
| Median length | 25 |
| Mean length | 16.103007 |
| Min length | 3 |
Characters and Unicode
| Total characters | 43786265 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | TABLETS & CAPSULES |
|---|---|
| 2nd row | INJECTIONS |
| 3rd row | INJECTIONS |
| 4th row | LIQUIDS & SOLUTIONS |
| 5th row | IV FLUIDS, ELECTROLYTES, TPN |
Common Values
| Value | Count | Frequency (%) |
| INJECTIONS | 1183247 | |
| TABLETS & CAPSULES | 670016 | |
| IV FLUIDS, ELECTROLYTES, TPN | 468778 | 17.2% |
| SYRUP & SUSPENSION | 89640 | 3.3% |
| OINTMENTS, CREAMS & GELS | 69245 | 2.5% |
| INHALERS & RESPULES | 64098 | 2.4% |
| LIQUIDS & SOLUTIONS | 44421 | 1.6% |
| POWDER | 40087 | 1.5% |
| NUTRITIONAL SUPPLEMENTS | 29194 | 1.1% |
| VACCINE | 18426 | 0.7% |
| Other values (23) | 41984 | 1.5% |
Length
| Value | Count | Frequency (%) |
| injections | 1183247 | |
| 945655 | ||
| capsules | 670016 | |
| tablets | 670016 | |
| iv | 468778 | 7.7% |
| fluids | 468778 | 7.7% |
| electrolytes | 468778 | 7.7% |
| tpn | 468778 | 7.7% |
| syrup | 89642 | 1.5% |
| suspension | 89640 | 1.5% |
| Other values (39) | 592847 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 5162034 | |
| E | 4563368 | |
| T | 4216536 | |
| I | 3769067 | 8.6% |
| 3397039 | 7.8% | |
| N | 3373737 | 7.7% |
| L | 3097037 | 7.1% |
| C | 2431443 | 5.6% |
| O | 2017651 | 4.6% |
| U | 1540972 | 3.5% |
| Other values (17) | 10217381 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 38436769 | |
| Space Separator | 3397039 | 7.8% |
| Other Punctuation | 1952457 | 4.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 5162034 | |
| E | 4563368 | |
| T | 4216536 | |
| I | 3769067 | |
| N | 3373737 | |
| L | 3097037 | |
| C | 2431443 | 6.3% |
| O | 2017651 | 5.2% |
| U | 1540972 | 4.0% |
| A | 1537619 | 4.0% |
| Other values (13) | 6727305 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 1006801 | |
| & | 945655 | |
| . | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 3397039 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 38436769 | |
| Common | 5349496 | 12.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 5162034 | |
| E | 4563368 | |
| T | 4216536 | |
| I | 3769067 | |
| N | 3373737 | |
| L | 3097037 | |
| C | 2431443 | 6.3% |
| O | 2017651 | 5.2% |
| U | 1540972 | 4.0% |
| A | 1537619 | 4.0% |
| Other values (13) | 6727305 |
Common
| Value | Count | Frequency (%) |
| 3397039 | ||
| , | 1006801 | 18.8% |
| & | 945655 | 17.7% |
| . | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43786265 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 5162034 | |
| E | 4563368 | |
| T | 4216536 | |
| I | 3769067 | 8.6% |
| 3397039 | 7.8% | |
| N | 3373737 | 7.7% |
| L | 3097037 | 7.1% |
| C | 2431443 | 5.6% |
| O | 2017651 | 4.6% |
| U | 1540972 | 3.5% |
| Other values (17) | 10217381 |
SubCategoryL3
Categorical
| Distinct | 36 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9617 |
| Missing (%) | 0.4% |
| Memory size | 235.5 MiB |
| INTRAVENOUS & OTHER STERILE SOLUTIONS | |
|---|---|
| ANTI-INFECTIVES | |
| GASTROINTESTINAL & HEPATOBILIARY SYSTEM | |
| CARDIOVASCULAR & HEMATOPOIETIC SYSTEM | |
| CENTRAL NERVOUS SYSTEM | |
| Other values (31) |
Length
| Max length | 66 |
|---|---|
| Median length | 38 |
| Mean length | 25.988316 |
| Min length | 8 |
Characters and Unicode
| Total characters | 70415837 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | GASTROINTESTINAL & HEPATOBILIARY SYSTEM |
|---|---|
| 2nd row | CENTRAL NERVOUS SYSTEM |
| 3rd row | INTRAVENOUS & OTHER STERILE SOLUTIONS |
| 4th row | EAR & MOUTH/ THROAT |
| 5th row | INTRAVENOUS & OTHER STERILE SOLUTIONS |
Common Values
| Value | Count | Frequency (%) |
| INTRAVENOUS & OTHER STERILE SOLUTIONS | 570608 | |
| ANTI-INFECTIVES | 366863 | |
| GASTROINTESTINAL & HEPATOBILIARY SYSTEM | 343922 | |
| CARDIOVASCULAR & HEMATOPOIETIC SYSTEM | 313090 | |
| CENTRAL NERVOUS SYSTEM | 278159 | |
| VITAMINS & MINERALS | 142456 | 5.2% |
| RESPIRATORY SYSTEM | 131322 | 4.8% |
| HORMONES | 98809 | 3.6% |
| ANAESTHETICS | 98699 | 3.6% |
| NUTRITION | 87861 | 3.2% |
| Other values (26) | 277730 |
Length
| Value | Count | Frequency (%) |
| 1430168 | ||
| system | 1179223 | |
| intravenous | 570608 | 7.0% |
| other | 570608 | 7.0% |
| sterile | 570608 | 7.0% |
| solutions | 570608 | 7.0% |
| anti-infectives | 366863 | 4.5% |
| gastrointestinal | 343931 | 4.2% |
| hepatobiliary | 343922 | 4.2% |
| hematopoietic | 313090 | 3.8% |
| Other values (55) | 1940135 |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 7346663 | |
| S | 7131971 | |
| E | 6973523 | |
| I | 6197439 | 8.8% |
| 5490245 | 7.8% | |
| O | 5121720 | 7.3% |
| A | 4680824 | 6.6% |
| N | 4578334 | 6.5% |
| R | 4456016 | 6.3% |
| L | 2923223 | 4.2% |
| Other values (25) | 15515879 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 63039964 | |
| Space Separator | 5490245 | 7.8% |
| Other Punctuation | 1456921 | 2.1% |
| Dash Punctuation | 428675 | 0.6% |
| Lowercase Letter | 32 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 7346663 | |
| S | 7131971 | |
| E | 6973523 | |
| I | 6197439 | |
| O | 5121720 | |
| A | 4680824 | |
| N | 4578334 | |
| R | 4456016 | 7.1% |
| L | 2923223 | 4.6% |
| M | 2199189 | 3.5% |
| Other values (12) | 11431062 |
Lowercase Letter
| Value | Count | Frequency (%) |
| y | 4 | |
| u | 4 | |
| r | 4 | |
| v | 4 | |
| e | 4 | |
| d | 4 | |
| i | 4 | |
| c | 4 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1438965 | |
| / | 15525 | 1.1% |
| , | 2431 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 5490245 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 428675 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 63039996 | |
| Common | 7375841 | 10.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 7346663 | |
| S | 7131971 | |
| E | 6973523 | |
| I | 6197439 | |
| O | 5121720 | |
| A | 4680824 | |
| N | 4578334 | |
| R | 4456016 | 7.1% |
| L | 2923223 | 4.6% |
| M | 2199189 | 3.5% |
| Other values (20) | 11431094 |
Common
| Value | Count | Frequency (%) |
| 5490245 | ||
| & | 1438965 | 19.5% |
| - | 428675 | 5.8% |
| / | 15525 | 0.2% |
| , | 2431 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 70415837 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 7346663 | |
| S | 7131971 | |
| E | 6973523 | |
| I | 6197439 | 8.8% |
| 5490245 | 7.8% | |
| O | 5121720 | 7.3% |
| A | 4680824 | 6.6% |
| N | 4578334 | 6.5% |
| R | 4456016 | 6.3% |
| L | 2923223 | 4.2% |
| Other values (25) | 15515879 |
Bill_Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4982656 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.585137 |
|---|---|
| Coefficient of variation (CV) | 0.55170675 |
| Kurtosis | -1.307667 |
| Mean | 6.4982656 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.019958661 |
| Sum | 17669668 |
| Variance | 12.853207 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 261265 | |
| 2 | 260863 | |
| 12 | 251629 | |
| 10 | 241769 | |
| 9 | 235343 | |
| 11 | 232622 | |
| 3 | 220717 | |
| 8 | 217232 | |
| 5 | 213263 | |
| 4 | 198405 | |
| Other values (2) | 386028 |
| Value | Count | Frequency (%) |
| 1 | 261265 | |
| 2 | 260863 | |
| 3 | 220717 | |
| 4 | 198405 | |
| 5 | 213263 | |
| 6 | 189628 | |
| 7 | 196400 | |
| 8 | 217232 | |
| 9 | 235343 | |
| 10 | 241769 |
| Value | Count | Frequency (%) |
| 12 | 251629 | |
| 11 | 232622 | |
| 10 | 241769 | |
| 9 | 235343 | |
| 8 | 217232 | |
| 7 | 196400 | |
| 6 | 189628 | |
| 5 | 213263 | |
| 4 | 198405 | |
| 3 | 220717 |
Bill_Year
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 178.9 MiB |
| 2022 | |
|---|---|
| 2021 | |
| 2020 | |
| 2019 | |
| 2023 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 10876544 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2019 |
|---|---|
| 2nd row | 2019 |
| 3rd row | 2019 |
| 4th row | 2019 |
| 5th row | 2019 |
Common Values
| Value | Count | Frequency (%) |
| 2022 | 900714 | |
| 2021 | 732418 | |
| 2020 | 464638 | |
| 2019 | 420421 | |
| 2023 | 200945 | 7.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2022 | 900714 | |
| 2021 | 732418 | |
| 2020 | 464638 | |
| 2019 | 420421 | |
| 2023 | 200945 | 7.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 5918565 | |
| 0 | 3183774 | |
| 1 | 1152839 | 10.6% |
| 9 | 420421 | 3.9% |
| 3 | 200945 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10876544 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 5918565 | |
| 0 | 3183774 | |
| 1 | 1152839 | 10.6% |
| 9 | 420421 | 3.9% |
| 3 | 200945 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10876544 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 5918565 | |
| 0 | 3183774 | |
| 1 | 1152839 | 10.6% |
| 9 | 420421 | 3.9% |
| 3 | 200945 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10876544 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 5918565 | |
| 0 | 3183774 | |
| 1 | 1152839 | 10.6% |
| 9 | 420421 | 3.9% |
| 3 | 200945 | 1.8% |
Bill_Day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.67448 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7520599 |
|---|---|
| Coefficient of variation (CV) | 0.55836367 |
| Kurtosis | -1.189178 |
| Mean | 15.67448 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.014145068 |
| Sum | 42621042 |
| Variance | 76.598553 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 92584 | 3.4% |
| 21 | 92572 | 3.4% |
| 9 | 92106 | 3.4% |
| 17 | 91899 | 3.4% |
| 16 | 91764 | 3.4% |
| 18 | 91495 | 3.4% |
| 11 | 91103 | 3.4% |
| 13 | 91024 | 3.3% |
| 4 | 91004 | 3.3% |
| 6 | 90854 | 3.3% |
| Other values (21) | 1802731 |
| Value | Count | Frequency (%) |
| 1 | 84785 | |
| 2 | 88102 | |
| 3 | 90689 | |
| 4 | 91004 | |
| 5 | 89504 | |
| 6 | 90854 | |
| 7 | 92584 | |
| 8 | 88500 | |
| 9 | 92106 | |
| 10 | 90010 |
| Value | Count | Frequency (%) |
| 31 | 47915 | |
| 30 | 79981 | |
| 29 | 81163 | |
| 28 | 90501 | |
| 27 | 88561 | |
| 26 | 87346 | |
| 25 | 86727 | |
| 24 | 90253 | |
| 23 | 88994 | |
| 22 | 88566 |
Bill_Week
Real number (ℝ)
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.443931 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 12 |
| median | 27 |
| Q3 | 40 |
| 95-th percentile | 50 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 15.656445 |
|---|---|
| Coefficient of variation (CV) | 0.59206191 |
| Kurtosis | -1.3079171 |
| Mean | 26.443931 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.0099876765 |
| Sum | 71904646 |
| Variance | 245.12426 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 66354 | 2.4% |
| 9 | 65741 | 2.4% |
| 5 | 65566 | 2.4% |
| 7 | 65204 | 2.4% |
| 4 | 62772 | 2.3% |
| 6 | 62467 | 2.3% |
| 50 | 60057 | 2.2% |
| 49 | 59083 | 2.2% |
| 51 | 58320 | 2.1% |
| 2 | 57737 | 2.1% |
| Other values (43) | 2095835 |
| Value | Count | Frequency (%) |
| 1 | 57075 | |
| 2 | 57737 | |
| 3 | 57620 | |
| 4 | 62772 | |
| 5 | 65566 | |
| 6 | 62467 | |
| 7 | 65204 | |
| 8 | 66354 | |
| 9 | 65741 | |
| 10 | 53133 |
| Value | Count | Frequency (%) |
| 53 | 7256 | 0.3% |
| 52 | 50637 | |
| 51 | 58320 | |
| 50 | 60057 | |
| 49 | 59083 | |
| 48 | 55518 | |
| 47 | 57001 | |
| 46 | 53979 | |
| 45 | 54066 | |
| 44 | 50013 |
| UHID | TQty | UCPwithoutGST | PurGSTPer | MRP | TotalCost | TotalDiscount | NetSales | ReturnMRP | Bill_Month | Bill_Day | Bill_Week | SalesType | PharmacyType | SpecialisationName | Department | IsFormulary | Formulary | SubCategory | SubCategoryL3 | Bill_Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| UHID | 1.000 | 0.015 | -0.021 | 0.029 | -0.014 | -0.001 | 0.089 | 0.004 | -0.011 | 0.037 | 0.001 | 0.032 | 0.038 | 0.143 | 0.199 | 0.112 | 0.087 | 0.070 | 0.028 | 0.040 | 0.678 |
| TQty | 0.015 | 1.000 | -0.126 | 0.109 | -0.113 | 0.188 | 0.113 | 0.450 | -0.547 | 0.015 | -0.005 | 0.014 | 0.029 | 0.033 | 0.008 | 0.041 | 0.000 | 0.004 | 0.038 | 0.025 | 0.015 |
| UCPwithoutGST | -0.021 | -0.126 | 1.000 | 0.044 | 0.954 | 0.890 | 0.097 | 0.698 | -0.002 | 0.010 | 0.002 | 0.009 | 0.002 | 0.003 | 0.012 | 0.003 | 0.007 | 0.004 | 0.007 | 0.025 | 0.003 |
| PurGSTPer | 0.029 | 0.109 | 0.044 | 1.000 | -0.021 | 0.083 | 0.758 | 0.080 | -0.156 | 0.002 | 0.001 | 0.000 | 0.136 | 0.213 | 0.054 | 0.109 | 0.008 | 0.054 | 0.100 | 0.077 | 0.051 |
| MRP | -0.014 | -0.113 | 0.954 | -0.021 | 1.000 | 0.855 | 0.036 | 0.727 | 0.019 | 0.009 | 0.002 | 0.009 | 0.003 | 0.003 | 0.011 | 0.006 | 0.008 | 0.004 | 0.007 | 0.028 | 0.003 |
| TotalCost | -0.001 | 0.188 | 0.890 | 0.083 | 0.855 | 1.000 | 0.146 | 0.790 | -0.005 | 0.012 | -0.000 | 0.011 | 0.002 | 0.003 | 0.011 | 0.000 | 0.008 | 0.004 | 0.006 | 0.027 | 0.004 |
| TotalDiscount | 0.089 | 0.113 | 0.097 | 0.758 | 0.036 | 0.146 | 1.000 | 0.129 | -0.136 | 0.002 | 0.001 | -0.001 | 0.002 | 0.004 | 0.000 | 0.006 | 0.002 | 0.007 | 0.000 | 0.004 | 0.002 |
| NetSales | 0.004 | 0.450 | 0.698 | 0.080 | 0.727 | 0.790 | 0.129 | 1.000 | -0.516 | 0.006 | -0.000 | 0.006 | 0.004 | 0.004 | 0.011 | 0.003 | 0.011 | 0.004 | 0.017 | 0.028 | 0.004 |
| ReturnMRP | -0.011 | -0.547 | -0.002 | -0.156 | 0.019 | -0.005 | -0.136 | -0.516 | 1.000 | 0.009 | -0.001 | 0.007 | 0.019 | 0.004 | 0.000 | 0.003 | 0.004 | 0.008 | 0.003 | 0.008 | 0.003 |
| Bill_Month | 0.037 | 0.015 | 0.010 | 0.002 | 0.009 | 0.012 | 0.002 | 0.006 | 0.009 | 1.000 | 0.016 | 0.976 | 0.017 | 0.049 | 0.097 | 0.078 | 0.048 | 0.017 | 0.013 | 0.017 | 0.264 |
| Bill_Day | 0.001 | -0.005 | 0.002 | 0.001 | 0.002 | -0.000 | 0.001 | -0.000 | -0.001 | 0.016 | 1.000 | 0.078 | 0.006 | 0.009 | 0.023 | 0.010 | 0.008 | 0.003 | 0.004 | 0.005 | 0.036 |
| Bill_Week | 0.032 | 0.014 | 0.009 | 0.000 | 0.009 | 0.011 | -0.001 | 0.006 | 0.007 | 0.976 | 0.078 | 1.000 | 0.016 | 0.047 | 0.096 | 0.074 | 0.048 | 0.018 | 0.014 | 0.017 | 0.260 |
| SalesType | 0.038 | 0.029 | 0.002 | 0.136 | 0.003 | 0.002 | 0.002 | 0.004 | 0.019 | 0.017 | 0.006 | 0.016 | 1.000 | 0.715 | 0.317 | 0.458 | 0.013 | 0.059 | 0.283 | 0.171 | 0.054 |
| PharmacyType | 0.143 | 0.033 | 0.003 | 0.213 | 0.003 | 0.003 | 0.004 | 0.004 | 0.004 | 0.049 | 0.009 | 0.047 | 0.715 | 1.000 | 0.366 | 0.661 | 0.000 | 0.088 | 0.428 | 0.254 | 0.094 |
| SpecialisationName | 0.199 | 0.008 | 0.012 | 0.054 | 0.011 | 0.011 | 0.000 | 0.011 | 0.000 | 0.097 | 0.023 | 0.096 | 0.317 | 0.366 | 1.000 | 0.285 | 0.121 | 0.088 | 0.138 | 0.162 | 0.265 |
| Department | 0.112 | 0.041 | 0.003 | 0.109 | 0.006 | 0.000 | 0.006 | 0.003 | 0.003 | 0.078 | 0.010 | 0.074 | 0.458 | 0.661 | 0.285 | 1.000 | 0.061 | 0.048 | 0.172 | 0.140 | 0.198 |
| IsFormulary | 0.087 | 0.000 | 0.007 | 0.008 | 0.008 | 0.008 | 0.002 | 0.011 | 0.004 | 0.048 | 0.008 | 0.048 | 0.013 | 0.000 | 0.121 | 0.061 | 1.000 | 1.000 | 0.146 | 0.191 | 0.058 |
| Formulary | 0.070 | 0.004 | 0.004 | 0.054 | 0.004 | 0.004 | 0.007 | 0.004 | 0.008 | 0.017 | 0.003 | 0.018 | 0.059 | 0.088 | 0.088 | 0.048 | 1.000 | 1.000 | 0.150 | 0.243 | 0.088 |
| SubCategory | 0.028 | 0.038 | 0.007 | 0.100 | 0.007 | 0.006 | 0.000 | 0.017 | 0.003 | 0.013 | 0.004 | 0.014 | 0.283 | 0.428 | 0.138 | 0.172 | 0.146 | 0.150 | 1.000 | 0.401 | 0.049 |
| SubCategoryL3 | 0.040 | 0.025 | 0.025 | 0.077 | 0.028 | 0.027 | 0.004 | 0.028 | 0.008 | 0.017 | 0.005 | 0.017 | 0.171 | 0.254 | 0.162 | 0.140 | 0.191 | 0.243 | 0.401 | 1.000 | 0.057 |
| Bill_Year | 0.678 | 0.015 | 0.003 | 0.051 | 0.003 | 0.004 | 0.002 | 0.004 | 0.003 | 0.264 | 0.036 | 0.260 | 0.054 | 0.094 | 0.265 | 0.198 | 0.058 | 0.088 | 0.049 | 0.057 | 1.000 |
| SalesType | UHID | PharmacyType | SpecialisationName | Department | BillNo | BillDate | ItemName | Item_Code | IsFormulary | Formulary | TQty | UCPwithoutGST | PurGSTPer | MRP | TotalCost | TotalDiscount | NetSales | ReturnMRP | GenericName | Category | SubCategory | SubCategoryL3 | Bill_Month | Bill_Year | Bill_Day | Bill_Week | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08659 | 2019-01-30 | NEKSIUM (ESOMEPRAZOLE) 20MG TAB 1x10 PFIZER | PH001036 | Yes | P1 | 1 | 48.00 | 0 | 63.00 | 53.76 | 0.0 | 63.00 | 0.0 | ESOMEPRAZOLE 20MG | DRUGS | TABLETS & CAPSULES | GASTROINTESTINAL & HEPATOBILIARY SYSTEM | 1 | 2019 | 30 | 5 |
| 7 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08923 | 2019-01-31 | FENSTUD (FENTANYL) 50MCG/10ML INJ RUSAN | PH001660 | Yes | P2 | 3 | 69.00 | 0 | 230.70 | 231.84 | 0.0 | 692.10 | 0.0 | FENTANYL INJ 500MCG/10ML | DRUGS | INJECTIONS | CENTRAL NERVOUS SYSTEM | 1 | 2019 | 31 | 5 |
| 12 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08981 | 2019-01-31 | CALCIUM GLUCONATE 10ML INJ 1X1 HINDU | PH000543 | Yes | P1 | 5 | 4.00 | 0 | 5.82 | 22.40 | 0.0 | 29.10 | 0.0 | CALCIUM GLUCONATE | DRUGS | INJECTIONS | INTRAVENOUS & OTHER STERILE SOLUTIONS | 1 | 2019 | 31 | 5 |
| 13 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08981 | 2019-01-31 | CLOHEX MOUTH WASH 150ML DR REDDYS | PH000604 | Yes | P1 | 1 | 69.95 | 0 | 102.00 | 78.34 | 0.0 | 102.00 | 0.0 | CHLORHEXIDINE GLUCONATE 0.2%W/V | DRUGS | LIQUIDS & SOLUTIONS | EAR & MOUTH/ THROAT | 1 | 2019 | 31 | 5 |
| 14 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08981 | 2019-01-31 | DEXTROSE 5% 500ML CLARIS | PH000564 | Yes | P1 | 2 | 16.50 | 0 | 31.02 | 36.96 | 0.0 | 62.04 | 0.0 | DEXTROSE 5% W/V IV FLUID | DRUGS | IV FLUIDS, ELECTROLYTES, TPN | INTRAVENOUS & OTHER STERILE SOLUTIONS | 1 | 2019 | 31 | 5 |
| 16 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08981 | 2019-01-31 | EFIPRES (EPHEDRINE) 1ML INJ NEON | PH000354 | Yes | P1 | 1 | 21.95 | 0 | 28.00 | 24.58 | 0.0 | 28.00 | 0.0 | EPHEDRINE 30MG | DRUGS | INJECTIONS | CARDIOVASCULAR & HEMATOPOIETIC SYSTEM | 1 | 2019 | 31 | 5 |
| 17 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08981 | 2019-01-31 | FLEXBUMIN (HUMAN ALBUMIN) 20% 100ML INJ BAXTER | PH000401 | No | NaN | 2 | 3804.00 | 0 | 4765.00 | 7988.40 | 0.0 | 9530.00 | 0.0 | HUMAN ALBUMIN 20% INJ | DRUGS | INJECTIONS | INTRAVENOUS & OTHER STERILE SOLUTIONS | 1 | 2019 | 31 | 5 |
| 21 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08981 | 2019-01-31 | HAEMACCEL 500ML ABBOTT | PH000560 | Yes | P1 | 4 | 273.57 | 0 | 383.00 | 1225.59 | 0.0 | 1532.00 | 0.0 | SODIUM CHLORIDE 0.85G + POTASSIUM CHLORIDE 0.038G + CALCIUM CHLORIDE 0.070G | DRUGS | IV FLUIDS, ELECTROLYTES, TPN | INTRAVENOUS & OTHER STERILE SOLUTIONS | 1 | 2019 | 31 | 5 |
| 23 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08981 | 2019-01-31 | HUMAN ALBUMIN 5% 250ML INJ BAXTER | PH000402 | Yes | P1 | 2 | 2700.00 | 0 | 3054.00 | 5670.00 | 0.0 | 6108.00 | 0.0 | HUMAN ALBUMIN 5% 250ML INJ | DRUGS | INJECTIONS | INTRAVENOUS & OTHER STERILE SOLUTIONS | 1 | 2019 | 31 | 5 |
| 24 | IP Dispense | 1.201800e+10 | IP | Liver Disease and Transplantation | MS IP Pharmacy | PDS19-08981 | 2019-01-31 | KABILYTE (MULTIPLE ELECTROLYTES) 500ML FLEXBAG FRESENIUS | PH000561 | Yes | P1 | 4 | 124.32 | 0 | 196.90 | 556.95 | 0.0 | 787.60 | 0.0 | MULTIPLE ELECTROLYTES 500ML IVF | DRUGS | IV FLUIDS, ELECTROLYTES, TPN | INTRAVENOUS & OTHER STERILE SOLUTIONS | 1 | 2019 | 31 | 5 |
| SalesType | UHID | PharmacyType | SpecialisationName | Department | BillNo | BillDate | ItemName | Item_Code | IsFormulary | Formulary | TQty | UCPwithoutGST | PurGSTPer | MRP | TotalCost | TotalDiscount | NetSales | ReturnMRP | GenericName | Category | SubCategory | SubCategoryL3 | Bill_Month | Bill_Year | Bill_Day | Bill_Week | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5643249 | OTC Return | NaN | OTC | Urology | NaN | SLR22-144571 | 2022-09-14 | VSL 3 (LACTIC ACID BACTERIA+BIFIDOBACTERIA) CAP 1x10 SUN PHARMA | PH001697 | Yes | P1 | -2 | 273.47 | 12 | 403.00 | 612.57 | 0.0 | 0.0 | 725.40 | LACTIC ACID BACTERIA + BIFIDOBACTERIA CAP | DRUGS | TABLETS & CAPSULES | GASTROINTESTINAL & HEPATOBILIARY SYSTEM | 9 | 2022 | 14 | 37 |
| 5643250 | OTC Return | NaN | OTC | Urology | NaN | SLR22-146778 | 2022-09-17 | CRANPAC-D (CRANBERRY AND D-MANNOSE) TAB 1X10S IPCA | PH003483 | Yes | P1 | -3 | 235.09 | 18 | 365.00 | 832.22 | 0.0 | 0.0 | 985.50 | CRANBERRY AND D-MANNOSE | DRUGS | TABLETS & CAPSULES | NUTRITION | 9 | 2022 | 17 | 37 |
| 5643251 | OTC Return | NaN | OTC | Urology | NaN | SLR22-146778 | 2022-09-17 | EVALON (ESTRIOL) 15GM CREAM MSD | PH002315 | Yes | P1 | -1 | 314.11 | 12 | 462.90 | 351.80 | 0.0 | 0.0 | 416.61 | ESTRIOL 1MG | DRUGS | OINTMENTS, CREAMS & GELS | HORMONES | 9 | 2022 | 17 | 37 |
| 5643252 | OTC Return | NaN | OTC | Urology | NaN | SLR22-146778 | 2022-09-17 | MARTIFUR (NITROFURANTOIN) 100MG TAB 1x14 WALTER | PH001174 | No | NaN | -2 | 56.70 | 12 | 79.57 | 127.01 | 0.0 | 0.0 | 143.22 | NITROFURANTOIN 100MG TAB | DRUGS | TABLETS & CAPSULES | ANTI-INFECTIVES | 9 | 2022 | 17 | 37 |
| 5643253 | OTC Return | NaN | OTC | Urology | NaN | SLR22-58568 | 2022-04-26 | PEGMOVE (POLYETHYLENE GLYCOL) 119GM POW SUN PHARMA | PH002730 | Yes | P1 | -2 | 153.60 | 12 | 224.00 | 344.06 | 0.0 | 0.0 | 403.20 | POLYETHYLENE GLYCOL POWDER | DRUGS | POWDER | GASTROINTESTINAL & HEPATOBILIARY SYSTEM | 4 | 2022 | 26 | 17 |
| 5643254 | OTC Return | NaN | OTC | Urology | NaN | SLR22-71319 | 2022-05-18 | CRESTOR (ROSUVASTATIN) 10 MG TAB 1x30 ASTRAZENECA | PH002571 | Yes | P1 | -1 | 445.71 | 12 | 624.00 | 499.20 | 0.0 | 0.0 | 561.60 | ROSUVASTATIN 10MG TAB | DRUGS | TABLETS & CAPSULES | CARDIOVASCULAR & HEMATOPOIETIC SYSTEM | 5 | 2022 | 18 | 20 |
| 5643255 | OTC Return | NaN | OTC | Urology | NaN | SLR22-71319 | 2022-05-18 | FLAVEDON MR (TRIMETAZIDINE) TAB 1x10 SERDIA | PH001302 | Yes | P1 | -1 | 89.76 | 12 | 130.90 | 100.53 | 0.0 | 0.0 | 117.81 | TRIMETAZIDINE 35MG | DRUGS | TABLETS & CAPSULES | CARDIOVASCULAR & HEMATOPOIETIC SYSTEM | 5 | 2022 | 18 | 20 |
| 5643256 | OTC Return | NaN | OTC | Urology | NaN | SLR22-84863 | 2022-06-10 | ARG9 SACHET 5GM NOUVEAU MEDICAMENTS | PH002388 | Yes | P1 | -33 | 30.28 | 12 | 42.40 | 1119.15 | 0.0 | 0.0 | 1399.20 | L-ARGININE 3GM + PROANTHOCYANIDINS 75MG/GM POWDER | DRUGS | POWDER | VITAMINS & MINERALS | 6 | 2022 | 10 | 23 |
| 5643257 | OTC Return | NaN | OTC | Urology | NaN | SLR22-94095 | 2022-06-26 | UDILIV (URSODEOXYCHOLIC ACID) 300MG TAB 1x15 ABBOTT | PH000873 | Yes | P1 | -3 | 397.21 | 5 | 694.19 | 1251.21 | 0.0 | 0.0 | 1874.31 | URSODEOXYCHOLIC ACID 300MG TAB | DRUGS | TABLETS & CAPSULES | GASTROINTESTINAL & HEPATOBILIARY SYSTEM | 6 | 2022 | 26 | 25 |
| 5643258 | OTC Return | NaN | OTC | Urology | NaN | SLR22-94095 | 2022-06-26 | URIMAX D (TAMSULOZIN 0.4MG + DUTASTERIDE 0.5MG) TAB 1x10 CIPLA | PH000119 | Yes | P1 | -4 | 375.54 | 12 | 525.74 | 1682.42 | 0.0 | 0.0 | 1892.68 | TAMSULOSIN 0.4MG + DUTASTERIDE 0.5MG TAB | DRUGS | TABLETS & CAPSULES | GENITO-URINARY SYSTEM | 6 | 2022 | 26 | 25 |